Overview
Brought to you by YData
Dataset statistics
| Number of variables | 19 |
|---|---|
| Number of observations | 37500 |
| Missing cells | 111133 |
| Missing cells (%) | 15.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 5.4 MiB |
| Average record size in memory | 152.0 B |
Variable types
| Numeric | 12 |
|---|---|
| Text | 5 |
| DateTime | 1 |
| Categorical | 1 |
review/appearance is highly overall correlated with review/palate | High correlation |
review/aroma is highly overall correlated with review/overall and 2 other fields | High correlation |
review/overall is highly overall correlated with review/aroma and 2 other fields | High correlation |
review/palate is highly overall correlated with review/appearance and 3 other fields | High correlation |
review/taste is highly overall correlated with review/aroma and 2 other fields | High correlation |
user/ageInSeconds is highly overall correlated with user/birthdayUnix | High correlation |
user/birthdayUnix is highly overall correlated with user/ageInSeconds | High correlation |
user/gender is highly imbalanced (88.2%) | Imbalance |
user/ageInSeconds has 29644 (79.1%) missing values | Missing |
user/birthdayRaw has 29644 (79.1%) missing values | Missing |
user/birthdayUnix has 29644 (79.1%) missing values | Missing |
user/gender has 22186 (59.2%) missing values | Missing |
df_index is uniformly distributed | Uniform |
df_index has unique values | Unique |
Reproduction
| Analysis started | 2024-11-13 17:28:47.331295 |
|---|---|
| Analysis finished | 2024-11-13 17:29:33.231306 |
| Duration | 45.9 seconds |
| Software version | ydata-profiling vv4.12.0 |
| Download configuration | config.json |
Variables
df_index
Real number (ℝ)
Uniform Unique
| Distinct | 37500 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 24951.888 |
| Minimum | 0 |
|---|---|
| Maximum | 49999 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2495.95 |
| Q1 | 12422.5 |
| median | 24942.5 |
| Q3 | 37416.75 |
| 95-th percentile | 47482.1 |
| Maximum | 49999 |
| Range | 49999 |
| Interquartile range (IQR) | 24994.25 |
Descriptive statistics
| Standard deviation | 14434.01 |
|---|---|
| Coefficient of variation (CV) | 0.57847366 |
| Kurtosis | -1.2005239 |
| Mean | 24951.888 |
| Median Absolute Deviation (MAD) | 12497 |
| Skewness | 0.0023210834 |
| Sum | 9.3569578 × 108 |
| Variance | 2.0834064 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 40163 | 1 | < 0.1% |
| 38112 | 1 | < 0.1% |
| 23470 | 1 | < 0.1% |
| 3776 | 1 | < 0.1% |
| 30174 | 1 | < 0.1% |
| 22375 | 1 | < 0.1% |
| 5080 | 1 | < 0.1% |
| 39079 | 1 | < 0.1% |
| 38353 | 1 | < 0.1% |
| 13419 | 1 | < 0.1% |
| Other values (37490) | 37490 |
| Value | Count | Frequency (%) |
| 0 | 1 | |
| 1 | 1 | |
| 2 | 1 | |
| 3 | 1 | |
| 4 | 1 | |
| 5 | 1 | |
| 6 | 1 | |
| 7 | 1 | |
| 9 | 1 | |
| 10 | 1 |
| Value | Count | Frequency (%) |
| 49999 | 1 | |
| 49998 | 1 | |
| 49997 | 1 | |
| 49996 | 1 | |
| 49994 | 1 | |
| 49993 | 1 | |
| 49992 | 1 | |
| 49991 | 1 | |
| 49990 | 1 | |
| 49988 | 1 |
beer/ABV
Real number (ℝ)
| Distinct | 126 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.4037248 |
| Minimum | 0.1 |
|---|---|
| Maximum | 57.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 4.4 |
| Q1 | 5.4 |
| median | 6.9 |
| Q3 | 9.4 |
| 95-th percentile | 11.2 |
| Maximum | 57.7 |
| Range | 57.6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.3181453 |
|---|---|
| Coefficient of variation (CV) | 0.31310528 |
| Kurtosis | 9.1537636 |
| Mean | 7.4037248 |
| Median Absolute Deviation (MAD) | 1.6 |
| Skewness | 0.94168799 |
| Sum | 277639.68 |
| Variance | 5.3737978 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6.5 | 2096 | 5.6% |
| 5 | 2015 | 5.4% |
| 8.3 | 1890 | 5.0% |
| 6.6 | 1848 | 4.9% |
| 9.4 | 1847 | 4.9% |
| 5.4 | 1711 | 4.6% |
| 12 | 1500 | 4.0% |
| 11.2 | 1441 | 3.8% |
| 8.5 | 1349 | 3.6% |
| 4.4 | 1341 | 3.6% |
| Other values (116) | 20462 |
| Value | Count | Frequency (%) |
| 0.1 | 2 | < 0.1% |
| 0.5 | 2 | < 0.1% |
| 1.5 | 3 | < 0.1% |
| 2.2 | 2 | < 0.1% |
| 2.4 | 6 | |
| 2.5 | 2 | < 0.1% |
| 2.8 | 8 | |
| 3 | 9 | |
| 3.1 | 6 | |
| 3.2 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 57.7 | 1 | < 0.1% |
| 43 | 2 | < 0.1% |
| 39.44 | 1 | < 0.1% |
| 30.86 | 1 | < 0.1% |
| 16 | 7 | < 0.1% |
| 15 | 13 | < 0.1% |
| 14.5 | 1 | < 0.1% |
| 14 | 6 | < 0.1% |
| 13 | 101 | |
| 12.9 | 4 | < 0.1% |
beer/beerId
Real number (ℝ)
| Distinct | 1731 |
|---|---|
| Distinct (%) | 4.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 21861.152 |
| Minimum | 175 |
|---|---|
| Maximum | 77207 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 175 |
|---|---|
| 5-th percentile | 727 |
| Q1 | 5441 |
| median | 17538 |
| Q3 | 34146 |
| 95-th percentile | 58053 |
| Maximum | 77207 |
| Range | 77032 |
| Interquartile range (IQR) | 28705 |
Descriptive statistics
| Standard deviation | 18923.131 |
|---|---|
| Coefficient of variation (CV) | 0.86560538 |
| Kurtosis | -0.31886527 |
| Mean | 21861.152 |
| Median Absolute Deviation (MAD) | 13524 |
| Skewness | 0.79963188 |
| Sum | 8.197932 × 108 |
| Variance | 3.5808488 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 11757 | 1883 | 5.0% |
| 19960 | 1441 | 3.8% |
| 5441 | 1064 | 2.8% |
| 16074 | 1051 | 2.8% |
| 7463 | 983 | 2.6% |
| 429 | 947 | 2.5% |
| 34146 | 857 | 2.3% |
| 21822 | 805 | 2.1% |
| 17538 | 800 | 2.1% |
| 35036 | 778 | 2.1% |
| Other values (1721) | 26891 |
| Value | Count | Frequency (%) |
| 175 | 56 | 0.1% |
| 176 | 92 | 0.2% |
| 178 | 68 | 0.2% |
| 429 | 947 | |
| 436 | 345 | 0.9% |
| 454 | 21 | 0.1% |
| 503 | 1 | < 0.1% |
| 505 | 26 | 0.1% |
| 507 | 29 | 0.1% |
| 508 | 2 | < 0.1% |
| Value | Count | Frequency (%) |
| 77207 | 1 | |
| 77199 | 1 | |
| 77198 | 1 | |
| 77116 | 1 | |
| 76999 | 1 | |
| 76998 | 1 | |
| 76997 | 2 | |
| 76996 | 2 | |
| 76995 | 2 | |
| 76963 | 1 |
beer/brewerId
Real number (ℝ)
| Distinct | 212 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3036.5951 |
| Minimum | 1 |
|---|---|
| Maximum | 27797 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 60 |
| Q1 | 395 |
| median | 1199 |
| Q3 | 1315 |
| 95-th percentile | 14879 |
| Maximum | 27797 |
| Range | 27796 |
| Interquartile range (IQR) | 920 |
Descriptive statistics
| Standard deviation | 5123.0847 |
|---|---|
| Coefficient of variation (CV) | 1.6871148 |
| Kurtosis | 4.5749629 |
| Mean | 3036.5951 |
| Median Absolute Deviation (MAD) | 625 |
| Skewness | 2.3536643 |
| Sum | 1.1387232 × 108 |
| Variance | 26245997 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1199 | 14976 | |
| 394 | 2937 | 7.8% |
| 14879 | 2351 | 6.3% |
| 263 | 1809 | 4.8% |
| 3268 | 1277 | 3.4% |
| 395 | 1226 | 3.3% |
| 365 | 1069 | 2.9% |
| 1 | 1017 | 2.7% |
| 1417 | 908 | 2.4% |
| 14 | 834 | 2.2% |
| Other values (202) | 9096 |
| Value | Count | Frequency (%) |
| 1 | 1017 | 2.7% |
| 14 | 834 | 2.2% |
| 60 | 451 | 1.2% |
| 163 | 427 | 1.1% |
| 263 | 1809 | |
| 289 | 55 | 0.1% |
| 365 | 1069 | 2.9% |
| 394 | 2937 | |
| 395 | 1226 | |
| 453 | 76 | 0.2% |
| Value | Count | Frequency (%) |
| 27797 | 2 | < 0.1% |
| 27133 | 1 | < 0.1% |
| 27079 | 1 | < 0.1% |
| 27021 | 2 | < 0.1% |
| 26990 | 15 | |
| 26983 | 1 | < 0.1% |
| 26946 | 6 | < 0.1% |
| 26816 | 6 | < 0.1% |
| 26612 | 6 | < 0.1% |
| 26409 | 1 | < 0.1% |
beer/name
Text
| Distinct | 1688 |
|---|---|
| Distinct (%) | 4.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 293.1 KiB |
Length
| Max length | 72 |
|---|---|
| Median length | 51 |
| Mean length | 23.02688 |
| Min length | 2 |
Unique
| Unique | 616 ? |
|---|---|
| Unique (%) | 1.6% |
Sample
| 1st row | Chiostro |
|---|---|
| 2nd row | Bearded Pat's Barleywine |
| 3rd row | Naughty Nellie's Ale |
| 4th row | Pilsner Urquell |
| 5th row | Black Sheep Ale (Special) |
| Value | Count | Frequency (%) |
| founders | 14976 | 12.0% |
| stout | 7222 | 5.8% |
| ale | 6620 | 5.3% |
| breakfast | 3334 | 2.7% |
| ipa | 3014 | 2.4% |
| pale | 2494 | 2.0% |
| double | 2379 | 1.9% |
| imperial | 2344 | 1.9% |
| porter | 2156 | 1.7% |
| stoudt's | 1831 | 1.5% |
| Other values (1933) | 78132 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 91610 | 10.6% |
| 87048 | 10.1% | |
| r | 60437 | 7.0% |
| o | 48520 | 5.6% |
| t | 46378 | 5.4% |
| a | 45167 | 5.2% |
| l | 40985 | 4.7% |
| u | 39475 | 4.6% |
| s | 39011 | 4.5% |
| n | 38429 | 4.5% |
| Other values (102) | 326448 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 603856 | |
| Uppercase Letter | 144808 | 16.8% |
| Space Separator | 87048 | 10.1% |
| Other Punctuation | 12081 | 1.4% |
| Decimal Number | 4433 | 0.5% |
| Close Punctuation | 3973 | 0.5% |
| Open Punctuation | 3973 | 0.5% |
| Dash Punctuation | 1657 | 0.2% |
| Currency Symbol | 700 | 0.1% |
| Other Symbol | 421 | < 0.1% |
| Other values (7) | 558 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 20058 | |
| F | 16515 | |
| B | 16351 | |
| A | 15982 | |
| P | 13118 | |
| I | 8592 | 5.9% |
| D | 7117 | 4.9% |
| R | 6843 | 4.7% |
| C | 5574 | 3.8% |
| O | 4768 | 3.3% |
| Other values (20) | 29890 |
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 91610 | |
| r | 60437 | |
| o | 48520 | 8.0% |
| t | 46378 | 7.7% |
| a | 45167 | 7.5% |
| l | 40985 | 6.8% |
| u | 39475 | 6.5% |
| s | 39011 | 6.5% |
| n | 38429 | 6.4% |
| d | 29243 | 4.8% |
| Other values (17) | 124601 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 6888 | |
| ' | 4567 | |
| ¡ | 256 | 2.1% |
| & | 139 | 1.2% |
| # | 55 | 0.5% |
| " | 46 | 0.4% |
| ; | 36 | 0.3% |
| : | 21 | 0.2% |
| % | 21 | 0.2% |
| , | 20 | 0.2% |
| Other values (3) | 32 | 0.3% |
Control
| Value | Count | Frequency (%) |
| | 35 | |
| | 33 | |
| | 28 | |
| | 4 | 3.4% |
| | 4 | 3.4% |
| | 3 | 2.6% |
| | 2 | 1.7% |
| | 2 | 1.7% |
| | 1 | 0.9% |
| | 1 | 0.9% |
| Other values (3) | 3 | 2.6% |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 1766 | |
| 2 | 900 | |
| 1 | 665 | 15.0% |
| 5 | 448 | 10.1% |
| 9 | 426 | 9.6% |
| 7 | 109 | 2.5% |
| 6 | 52 | 1.2% |
| 3 | 32 | 0.7% |
| 8 | 21 | 0.5% |
| 4 | 14 | 0.3% |
Other Number
| Value | Count | Frequency (%) |
| ¼ | 237 | |
| ½ | 15 | 5.8% |
| ³ | 6 | 2.3% |
| ¾ | 1 | 0.4% |
Other Symbol
| Value | Count | Frequency (%) |
| ¦ | 215 | |
| © | 191 | |
| ° | 15 | 3.6% |
Currency Symbol
| Value | Count | Frequency (%) |
| ¤ | 697 | |
| ¥ | 3 | 0.4% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ¨ | 34 | |
| ¸ | 33 |
Space Separator
| Value | Count | Frequency (%) |
| 87048 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 3973 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 3973 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 1657 |
Initial Punctuation
| Value | Count | Frequency (%) |
| « | 91 |
Format
| Value | Count | Frequency (%) |
| | 20 |
Math Symbol
| Value | Count | Frequency (%) |
| ± | 4 |
Other Letter
| Value | Count | Frequency (%) |
| ª | 1 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 748665 | |
| Common | 114843 | 13.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 91610 | 12.2% |
| r | 60437 | 8.1% |
| o | 48520 | 6.5% |
| t | 46378 | 6.2% |
| a | 45167 | 6.0% |
| l | 40985 | 5.5% |
| u | 39475 | 5.3% |
| s | 39011 | 5.2% |
| n | 38429 | 5.1% |
| d | 29243 | 3.9% |
| Other values (48) | 269410 |
Common
| Value | Count | Frequency (%) |
| 87048 | ||
| . | 6888 | 6.0% |
| ' | 4567 | 4.0% |
| ) | 3973 | 3.5% |
| ( | 3973 | 3.5% |
| 0 | 1766 | 1.5% |
| - | 1657 | 1.4% |
| 2 | 900 | 0.8% |
| ¤ | 697 | 0.6% |
| 1 | 665 | 0.6% |
| Other values (44) | 2709 | 2.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 859615 | |
| None | 3893 | 0.5% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 91610 | 10.7% |
| 87048 | 10.1% | |
| r | 60437 | 7.0% |
| o | 48520 | 5.6% |
| t | 46378 | 5.4% |
| a | 45167 | 5.3% |
| l | 40985 | 4.8% |
| u | 39475 | 4.6% |
| s | 39011 | 4.5% |
| n | 38429 | 4.5% |
| Other values (67) | 322555 |
None
| Value | Count | Frequency (%) |
| Ã | 1856 | |
| ¤ | 697 | 17.9% |
| ¡ | 256 | 6.6% |
| ¼ | 237 | 6.1% |
| ¦ | 215 | 5.5% |
| © | 191 | 4.9% |
| « | 91 | 2.3% |
| Â | 84 | 2.2% |
| | 35 | 0.9% |
| ¨ | 34 | 0.9% |
| Other values (25) | 197 | 5.1% |
beer/style
Text
| Distinct | 95 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 293.1 KiB |
Length
| Max length | 35 |
|---|---|
| Median length | 28 |
| Mean length | 19.10184 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Herbed / Spiced Beer |
|---|---|
| 2nd row | American Barleywine |
| 3rd row | American Pale Ale (APA) |
| 4th row | Czech Pilsener |
| 5th row | English Pale Ale |
| Value | Count | Frequency (%) |
| american | 16708 | |
| 12591 | 10.6% | |
| imperial | 9409 | 7.9% |
| ale | 9200 | 7.7% |
| double | 7377 | 6.2% |
| stout | 7327 | 6.2% |
| ipa | 6141 | 5.2% |
| pale | 4105 | 3.5% |
| beer | 2505 | 2.1% |
| porter | 2359 | 2.0% |
| Other values (103) | 40988 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 86523 | 12.1% |
| 81210 | 11.3% | |
| r | 48806 | 6.8% |
| a | 44921 | 6.3% |
| i | 41982 | 5.9% |
| l | 41894 | 5.8% |
| A | 36329 | 5.1% |
| n | 30485 | 4.3% |
| m | 28023 | 3.9% |
| t | 27948 | 3.9% |
| Other values (48) | 248198 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 493857 | |
| Uppercase Letter | 123322 | 17.2% |
| Space Separator | 81210 | 11.3% |
| Other Punctuation | 12655 | 1.8% |
| Open Punctuation | 2424 | 0.3% |
| Close Punctuation | 2424 | 0.3% |
| Currency Symbol | 410 | 0.1% |
| Dash Punctuation | 13 | < 0.1% |
| Modifier Symbol | 4 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 86523 | |
| r | 48806 | |
| a | 44921 | |
| i | 41982 | |
| l | 41894 | |
| n | 30485 | 6.2% |
| m | 28023 | 5.7% |
| t | 27948 | 5.7% |
| c | 26925 | 5.5% |
| o | 25325 | 5.1% |
| Other values (16) | 91025 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 36329 | |
| P | 16327 | |
| I | 15809 | |
| S | 12440 | 10.1% |
| D | 8767 | 7.1% |
| B | 7153 | 5.8% |
| R | 5428 | 4.4% |
| E | 4234 | 3.4% |
| H | 3379 | 2.7% |
| W | 3213 | 2.6% |
| Other values (13) | 10243 | 8.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 12481 | |
| & | 97 | 0.8% |
| ¶ | 77 | 0.6% |
Space Separator
| Value | Count | Frequency (%) |
| 81210 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2424 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2424 |
Currency Symbol
| Value | Count | Frequency (%) |
| ¤ | 410 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 13 |
Modifier Symbol
| Value | Count | Frequency (%) |
| ¨ | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 617179 | |
| Common | 99140 | 13.8% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 86523 | |
| r | 48806 | 7.9% |
| a | 44921 | 7.3% |
| i | 41982 | 6.8% |
| l | 41894 | 6.8% |
| A | 36329 | 5.9% |
| n | 30485 | 4.9% |
| m | 28023 | 4.5% |
| t | 27948 | 4.5% |
| c | 26925 | 4.4% |
| Other values (39) | 203343 |
Common
| Value | Count | Frequency (%) |
| 81210 | ||
| / | 12481 | 12.6% |
| ( | 2424 | 2.4% |
| ) | 2424 | 2.4% |
| ¤ | 410 | 0.4% |
| & | 97 | 0.1% |
| ¶ | 77 | 0.1% |
| - | 13 | < 0.1% |
| ¨ | 4 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 715337 | |
| None | 982 | 0.1% |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 86523 | 12.1% |
| 81210 | 11.4% | |
| r | 48806 | 6.8% |
| a | 44921 | 6.3% |
| i | 41982 | 5.9% |
| l | 41894 | 5.9% |
| A | 36329 | 5.1% |
| n | 30485 | 4.3% |
| m | 28023 | 3.9% |
| t | 27948 | 3.9% |
| Other values (44) | 247216 |
None
| Value | Count | Frequency (%) |
| Ã | 491 | |
| ¤ | 410 | |
| ¶ | 77 | 7.8% |
| ¨ | 4 | 0.4% |
review/appearance
Real number (ℝ)
High correlation
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9000533 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 3.5 |
| median | 4 |
| Q3 | 4.5 |
| 95-th percentile | 4.5 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.58877832 |
|---|---|
| Coefficient of variation (CV) | 0.15096674 |
| Kurtosis | 1.5151779 |
| Mean | 3.9000533 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -0.79263521 |
| Sum | 146252 |
| Variance | 0.34665991 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 4 | 16058 | |
| 4.5 | 7597 | |
| 3.5 | 7224 | |
| 3 | 3396 | 9.1% |
| 5 | 1862 | 5.0% |
| 2.5 | 807 | 2.2% |
| 2 | 437 | 1.2% |
| 1.5 | 84 | 0.2% |
| 1 | 34 | 0.1% |
| 0 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 34 | 0.1% |
| 1.5 | 84 | 0.2% |
| 2 | 437 | 1.2% |
| 2.5 | 807 | 2.2% |
| 3 | 3396 | 9.1% |
| 3.5 | 7224 | |
| 4 | 16058 | |
| 4.5 | 7597 | |
| 5 | 1862 | 5.0% |
| Value | Count | Frequency (%) |
| 5 | 1862 | 5.0% |
| 4.5 | 7597 | |
| 4 | 16058 | |
| 3.5 | 7224 | |
| 3 | 3396 | 9.1% |
| 2.5 | 807 | 2.2% |
| 2 | 437 | 1.2% |
| 1.5 | 84 | 0.2% |
| 1 | 34 | 0.1% |
| 0 | 1 | < 0.1% |
review/aroma
Real number (ℝ)
High correlation
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.87324 |
| Minimum | 1 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2.5 |
| Q1 | 3.5 |
| median | 4 |
| Q3 | 4.5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.68086533 |
|---|---|
| Coefficient of variation (CV) | 0.17578702 |
| Kurtosis | 1.166439 |
| Mean | 3.87324 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -0.83016929 |
| Sum | 145246.5 |
| Variance | 0.4635776 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 4 | 13034 | |
| 4.5 | 8407 | |
| 3.5 | 7473 | |
| 3 | 3855 | 10.3% |
| 5 | 2579 | 6.9% |
| 2.5 | 1094 | 2.9% |
| 2 | 773 | 2.1% |
| 1.5 | 195 | 0.5% |
| 1 | 90 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 90 | 0.2% |
| 1.5 | 195 | 0.5% |
| 2 | 773 | 2.1% |
| 2.5 | 1094 | 2.9% |
| 3 | 3855 | 10.3% |
| 3.5 | 7473 | |
| 4 | 13034 | |
| 4.5 | 8407 | |
| 5 | 2579 | 6.9% |
| Value | Count | Frequency (%) |
| 5 | 2579 | 6.9% |
| 4.5 | 8407 | |
| 4 | 13034 | |
| 3.5 | 7473 | |
| 3 | 3855 | 10.3% |
| 2.5 | 1094 | 2.9% |
| 2 | 773 | 2.1% |
| 1.5 | 195 | 0.5% |
| 1 | 90 | 0.2% |
review/overall
Real number (ℝ)
High correlation
| Distinct | 10 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.88944 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 1 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2.5 |
| Q1 | 3.5 |
| median | 4 |
| Q3 | 4.5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.70044955 |
|---|---|
| Coefficient of variation (CV) | 0.18009008 |
| Kurtosis | 1.7430682 |
| Mean | 3.88944 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -1.0401798 |
| Sum | 145854 |
| Variance | 0.49062957 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) |
| 4 | 13868 | |
| 4.5 | 8666 | |
| 3.5 | 6551 | |
| 3 | 3319 | 8.9% |
| 5 | 2671 | 7.1% |
| 2.5 | 1193 | 3.2% |
| 2 | 807 | 2.2% |
| 1.5 | 248 | 0.7% |
| 1 | 176 | 0.5% |
| 0 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 0 | 1 | < 0.1% |
| 1 | 176 | 0.5% |
| 1.5 | 248 | 0.7% |
| 2 | 807 | 2.2% |
| 2.5 | 1193 | 3.2% |
| 3 | 3319 | 8.9% |
| 3.5 | 6551 | |
| 4 | 13868 | |
| 4.5 | 8666 | |
| 5 | 2671 | 7.1% |
| Value | Count | Frequency (%) |
| 5 | 2671 | 7.1% |
| 4.5 | 8666 | |
| 4 | 13868 | |
| 3.5 | 6551 | |
| 3 | 3319 | 8.9% |
| 2.5 | 1193 | 3.2% |
| 2 | 807 | 2.2% |
| 1.5 | 248 | 0.7% |
| 1 | 176 | 0.5% |
| 0 | 1 | < 0.1% |
review/palate
Real number (ℝ)
High correlation
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.8548667 |
| Minimum | 1 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2.5 |
| Q1 | 3.5 |
| median | 4 |
| Q3 | 4.5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.66806802 |
|---|---|
| Coefficient of variation (CV) | 0.17330509 |
| Kurtosis | 1.333727 |
| Mean | 3.8548667 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -0.83914236 |
| Sum | 144557.5 |
| Variance | 0.44631488 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 4 | 14606 | |
| 4.5 | 7225 | |
| 3.5 | 7082 | |
| 3 | 4007 | 10.7% |
| 5 | 2422 | 6.5% |
| 2.5 | 1161 | 3.1% |
| 2 | 709 | 1.9% |
| 1.5 | 189 | 0.5% |
| 1 | 99 | 0.3% |
| Value | Count | Frequency (%) |
| 1 | 99 | 0.3% |
| 1.5 | 189 | 0.5% |
| 2 | 709 | 1.9% |
| 2.5 | 1161 | 3.1% |
| 3 | 4007 | 10.7% |
| 3.5 | 7082 | |
| 4 | 14606 | |
| 4.5 | 7225 | |
| 5 | 2422 | 6.5% |
| Value | Count | Frequency (%) |
| 5 | 2422 | 6.5% |
| 4.5 | 7225 | |
| 4 | 14606 | |
| 3.5 | 7082 | |
| 3 | 4007 | 10.7% |
| 2.5 | 1161 | 3.1% |
| 2 | 709 | 1.9% |
| 1.5 | 189 | 0.5% |
| 1 | 99 | 0.3% |
review/taste
Real number (ℝ)
High correlation
| Distinct | 9 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.92244 |
| Minimum | 1 |
|---|---|
| Maximum | 5 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2.5 |
| Q1 | 3.5 |
| median | 4 |
| Q3 | 4.5 |
| 95-th percentile | 5 |
| Maximum | 5 |
| Range | 4 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.71650411 |
|---|---|
| Coefficient of variation (CV) | 0.18266796 |
| Kurtosis | 1.4582962 |
| Mean | 3.92244 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -1.0004504 |
| Sum | 147091.5 |
| Variance | 0.51337814 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 4 | 12381 | |
| 4.5 | 9684 | |
| 3.5 | 6577 | |
| 5 | 3259 | 8.7% |
| 3 | 3141 | 8.4% |
| 2.5 | 1232 | 3.3% |
| 2 | 817 | 2.2% |
| 1.5 | 258 | 0.7% |
| 1 | 151 | 0.4% |
| Value | Count | Frequency (%) |
| 1 | 151 | 0.4% |
| 1.5 | 258 | 0.7% |
| 2 | 817 | 2.2% |
| 2.5 | 1232 | 3.3% |
| 3 | 3141 | 8.4% |
| 3.5 | 6577 | |
| 4 | 12381 | |
| 4.5 | 9684 | |
| 5 | 3259 | 8.7% |
| Value | Count | Frequency (%) |
| 5 | 3259 | 8.7% |
| 4.5 | 9684 | |
| 4 | 12381 | |
| 3.5 | 6577 | |
| 3 | 3141 | 8.4% |
| 2.5 | 1232 | 3.3% |
| 2 | 817 | 2.2% |
| 1.5 | 258 | 0.7% |
| 1 | 151 | 0.4% |
review/text
Text
| Distinct | 37482 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 10 |
| Missing (%) | < 0.1% |
| Memory size | 293.1 KiB |
Length
| Max length | 4721 |
|---|---|
| Median length | 2031 |
| Mean length | 719.07775 |
| Min length | 49 |
Unique
| Unique | 37474 ? |
|---|---|
| Unique (%) | > 99.9% |
Sample
| 1st row | Pours a clouded gold with a thin white head. Nose is quite floral with a larger amount of spices added. Definitely a spice forward fragrance. Flavor has an odd burn that hits on the first sip. After it fades it seems like a dirty vanilla aftertaste. Perhaps this is the absinthe? Regardless of that, I get a quite spiced tone on the tongue. Almost feel a little heat from it. I think that my inexperienced palate on these spices is contributing to my ignorance of what precisely they are. Overall a nice drinker indeed. |
|---|---|
| 2nd row | 12oz bottle into 8oz snifter. Deep ruby red hue with a one finger light tan head that settles to a thin rim along the glass. Sharp piercing hops with some light hard candy in the background. The hops provide some bitterness, but they aren't as sharp as I would have expected. Mostly a light candy flavor like in the aroma. Full bodied with good carbonation. The finish is some lingering sweet flavor with a bit of bitterness. A very sweet barleywine with a weird hard candy flavor that seemed to dominate. Not bad, but I would have liked a little more complexity. |
| 3rd row | First enjoyed at the brewpub about 2 years ago, I finally managed to get a bottle. Slightly hazy orange-amber topped with a two finger foamy white head. Very nice fruity aroma, soft and floral, tea and toast. Fruity, slightly grapefruity hop note, toast and biscuity malt balance. Hoppier and more floral when it warms up. Light-medium bodied, liked it better on draft but still a solid beer. |
| 4th row | First thing I noticed after pouring from green bottle to glass was the skunky smell. Overpowering. Lacing was minimal and faded quickly. Bottle had exp date and was still within freshness date. Taste was like drinking a milwaukee's best with some skunk. Just couldn't get over the skunky smell to finish my second bottle. Almost $10 a sixer, I would have been better off getting Bud Light. |
| 5th row | A: pours an amber with a one finger head but only with a very strong pour, head recedes to a light layer of foam with some large bubbles and good lacing S: sweet caramel and bread from the English malts comes through, some mild fruityness on the back end T: not a lot of complexity with this for me. I didn't expect much considering the style but it's just bland and lacking more bready layers M/D: more carbonated than I would have wanted. I would expect this to be much better on cask |
| Value | Count | Frequency (%) |
| a | 231704 | 4.8% |
| the | 209065 | 4.4% |
| and | 146195 | 3.0% |
| of | 119908 | 2.5% |
| is | 96485 | 2.0% |
| with | 86272 | 1.8% |
| to | 72600 | 1.5% |
| this | 69684 | 1.5% |
| i | 64118 | 1.3% |
| it | 60584 | 1.3% |
| Other values (67211) | 3647137 |
Most occurring characters
| Value | Count | Frequency (%) |
| 4671408 | ||
| e | 2375207 | 8.8% |
| t | 1964862 | 7.3% |
| a | 1744284 | 6.5% |
| o | 1587205 | 5.9% |
| i | 1426484 | 5.3% |
| s | 1332303 | 4.9% |
| n | 1221863 | 4.5% |
| r | 1196646 | 4.4% |
| l | 1081222 | 4.0% |
| Other values (84) | 8356741 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 20395548 | |
| Space Separator | 4671408 | 17.3% |
| Other Punctuation | 836523 | 3.1% |
| Uppercase Letter | 659430 | 2.4% |
| Control | 225425 | 0.8% |
| Decimal Number | 76392 | 0.3% |
| Dash Punctuation | 68992 | 0.3% |
| Close Punctuation | 10907 | < 0.1% |
| Open Punctuation | 10459 | < 0.1% |
| Math Symbol | 1585 | < 0.1% |
| Other values (3) | 1556 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 2375207 | |
| t | 1964862 | 9.6% |
| a | 1744284 | 8.6% |
| o | 1587205 | 7.8% |
| i | 1426484 | 7.0% |
| s | 1332303 | 6.5% |
| n | 1221863 | 6.0% |
| r | 1196646 | 5.9% |
| l | 1081222 | 5.3% |
| h | 1046549 | 5.1% |
| Other values (16) | 5418923 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 109918 | |
| T | 99159 | |
| A | 71370 | |
| S | 55928 | 8.5% |
| P | 37795 | 5.7% |
| M | 35388 | 5.4% |
| B | 33195 | 5.0% |
| D | 27011 | 4.1% |
| N | 21448 | 3.3% |
| F | 20492 | 3.1% |
| Other values (16) | 147726 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 434808 | |
| , | 247587 | |
| ' | 60502 | 7.2% |
| : | 38858 | 4.6% |
| / | 15194 | 1.8% |
| ! | 12762 | 1.5% |
| " | 8834 | 1.1% |
| ; | 5412 | 0.6% |
| ? | 4328 | 0.5% |
| % | 4270 | 0.5% |
| Other values (5) | 3968 | 0.5% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 17982 | |
| 2 | 16128 | |
| 0 | 14482 | |
| 5 | 6653 | 8.7% |
| 4 | 4759 | 6.2% |
| 9 | 3997 | 5.2% |
| 3 | 3995 | 5.2% |
| 6 | 3079 | 4.0% |
| 8 | 2720 | 3.6% |
| 7 | 2597 | 3.4% |
Math Symbol
| Value | Count | Frequency (%) |
| = | 744 | |
| + | 521 | |
| ~ | 168 | 10.6% |
| | | 152 | 9.6% |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 10801 | |
| ] | 105 | 1.0% |
| } | 1 | < 0.1% |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 10351 | |
| [ | 106 | 1.0% |
| { | 2 | < 0.1% |
Modifier Symbol
| Value | Count | Frequency (%) |
| ` | 33 | |
| ^ | 21 |
Space Separator
| Value | Count | Frequency (%) |
| 4671408 |
Control
| Value | Count | Frequency (%) |
| 225425 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 68992 |
Currency Symbol
| Value | Count | Frequency (%) |
| $ | 1274 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 228 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 21054978 | |
| Common | 5903247 | 21.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 2375207 | 11.3% |
| t | 1964862 | 9.3% |
| a | 1744284 | 8.3% |
| o | 1587205 | 7.5% |
| i | 1426484 | 6.8% |
| s | 1332303 | 6.3% |
| n | 1221863 | 5.8% |
| r | 1196646 | 5.7% |
| l | 1081222 | 5.1% |
| h | 1046549 | 5.0% |
| Other values (42) | 6078353 |
Common
| Value | Count | Frequency (%) |
| 4671408 | ||
| . | 434808 | 7.4% |
| , | 247587 | 4.2% |
| 225425 | 3.8% | |
| - | 68992 | 1.2% |
| ' | 60502 | 1.0% |
| : | 38858 | 0.7% |
| 1 | 17982 | 0.3% |
| 2 | 16128 | 0.3% |
| / | 15194 | 0.3% |
| Other values (32) | 106363 | 1.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 26958225 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 4671408 | ||
| e | 2375207 | 8.8% |
| t | 1964862 | 7.3% |
| a | 1744284 | 6.5% |
| o | 1587205 | 5.9% |
| i | 1426484 | 5.3% |
| s | 1332303 | 4.9% |
| n | 1221863 | 4.5% |
| r | 1196646 | 4.4% |
| l | 1081222 | 4.0% |
| Other values (84) | 8356741 |
| Distinct | 37490 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 293.1 KiB |
Length
| Max length | 107 |
|---|---|
| Median length | 106 |
| Mean length | 104.81691 |
| Min length | 100 |
Unique
| Unique | 37482 ? |
|---|---|
| Unique (%) | > 99.9% |
Sample
| 1st row | {'min': 38, 'hour': 3, 'mday': 16, 'sec': 10, 'year': 2008, 'wday': 1, 'mon': 12, 'isdst': 0, 'yday': 351} |
|---|---|
| 2nd row | {'min': 38, 'hour': 23, 'mday': 8, 'sec': 58, 'year': 2008, 'wday': 4, 'mon': 8, 'isdst': 0, 'yday': 221} |
| 3rd row | {'min': 7, 'hour': 18, 'mday': 26, 'sec': 2, 'year': 2004, 'wday': 4, 'mon': 11, 'isdst': 0, 'yday': 331} |
| 4th row | {'min': 7, 'hour': 1, 'mday': 20, 'sec': 5, 'year': 2011, 'wday': 0, 'mon': 6, 'isdst': 0, 'yday': 171} |
| 5th row | {'min': 51, 'hour': 6, 'mday': 12, 'sec': 48, 'year': 2011, 'wday': 5, 'mon': 3, 'isdst': 0, 'yday': 71} |
| Value | Count | Frequency (%) |
| 0 | 47189 | 7.0% |
| min | 37500 | 5.6% |
| year | 37500 | 5.6% |
| yday | 37500 | 5.6% |
| isdst | 37500 | 5.6% |
| mon | 37500 | 5.6% |
| wday | 37500 | 5.6% |
| sec | 37500 | 5.6% |
| mday | 37500 | 5.6% |
| hour | 37500 | 5.6% |
| Other values (380) | 290311 |
Most occurring characters
| Value | Count | Frequency (%) |
| ' | 675000 | |
| 637500 | ||
| : | 337500 | 8.6% |
| , | 300000 | 7.6% |
| y | 187500 | 4.8% |
| a | 150000 | 3.8% |
| d | 150000 | 3.8% |
| 0 | 135730 | 3.5% |
| 2 | 118581 | 3.0% |
| 1 | 116029 | 3.0% |
| Other values (21) | 1122794 |
Most occurring categories
| Value | Count | Frequency (%) |
| Other Punctuation | 1312500 | |
| Lowercase Letter | 1275000 | |
| Space Separator | 637500 | |
| Decimal Number | 630634 | |
| Close Punctuation | 37500 | 1.0% |
| Open Punctuation | 37500 | 1.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| y | 187500 | |
| a | 150000 | |
| d | 150000 | |
| m | 112500 | |
| s | 112500 | |
| o | 75000 | 5.9% |
| r | 75000 | 5.9% |
| n | 75000 | 5.9% |
| i | 75000 | 5.9% |
| e | 75000 | 5.9% |
| Other values (5) | 187500 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 135730 | |
| 2 | 118581 | |
| 1 | 116029 | |
| 3 | 56574 | |
| 5 | 44232 | 7.0% |
| 4 | 44225 | 7.0% |
| 6 | 32300 | 5.1% |
| 9 | 29354 | 4.7% |
| 8 | 27686 | 4.4% |
| 7 | 25923 | 4.1% |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 675000 | |
| : | 337500 | |
| , | 300000 |
Space Separator
| Value | Count | Frequency (%) |
| 637500 |
Close Punctuation
| Value | Count | Frequency (%) |
| } | 37500 |
Open Punctuation
| Value | Count | Frequency (%) |
| { | 37500 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2655634 | |
| Latin | 1275000 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| ' | 675000 | |
| 637500 | ||
| : | 337500 | |
| , | 300000 | |
| 0 | 135730 | 5.1% |
| 2 | 118581 | 4.5% |
| 1 | 116029 | 4.4% |
| 3 | 56574 | 2.1% |
| 5 | 44232 | 1.7% |
| 4 | 44225 | 1.7% |
| Other values (6) | 190263 | 7.2% |
Latin
| Value | Count | Frequency (%) |
| y | 187500 | |
| a | 150000 | |
| d | 150000 | |
| m | 112500 | |
| s | 112500 | |
| o | 75000 | 5.9% |
| r | 75000 | 5.9% |
| n | 75000 | 5.9% |
| i | 75000 | 5.9% |
| e | 75000 | 5.9% |
| Other values (5) | 187500 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 3930634 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| ' | 675000 | |
| 637500 | ||
| : | 337500 | 8.6% |
| , | 300000 | 7.6% |
| y | 187500 | 4.8% |
| a | 150000 | 3.8% |
| d | 150000 | 3.8% |
| 0 | 135730 | 3.5% |
| 2 | 118581 | 3.0% |
| 1 | 116029 | 3.0% |
| Other values (21) | 1122794 |
review/timeUnix
Real number (ℝ)
| Distinct | 37490 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.2327936 × 109 |
| Minimum | 9.262944 × 108 |
|---|---|
| Maximum | 1.3262666 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 9.262944 × 108 |
|---|---|
| 5-th percentile | 1.089043 × 109 |
| Q1 | 1.1891944 × 109 |
| median | 1.2481503 × 109 |
| Q3 | 1.2913303 × 109 |
| 95-th percentile | 1.3194199 × 109 |
| Maximum | 1.3262666 × 109 |
| Range | 3.999722 × 108 |
| Interquartile range (IQR) | 1.0213587 × 108 |
Descriptive statistics
| Standard deviation | 71909548 |
|---|---|
| Coefficient of variation (CV) | 0.058330564 |
| Kurtosis | 0.03389237 |
| Mean | 1.2327936 × 109 |
| Median Absolute Deviation (MAD) | 47784583 |
| Skewness | -0.86216245 |
| Sum | 4.6229762 × 1013 |
| Variance | 5.1709831 × 1015 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 926294401 | 3 | < 0.1% |
| 969580801 | 3 | < 0.1% |
| 1278875638 | 2 | < 0.1% |
| 1255108092 | 2 | < 0.1% |
| 1241043404 | 2 | < 0.1% |
| 1181754698 | 2 | < 0.1% |
| 955497601 | 2 | < 0.1% |
| 1268935767 | 2 | < 0.1% |
| 1269216814 | 1 | < 0.1% |
| 1234910269 | 1 | < 0.1% |
| Other values (37480) | 37480 |
| Value | Count | Frequency (%) |
| 926294401 | 3 | |
| 940723201 | 1 | < 0.1% |
| 955497601 | 2 | |
| 967852801 | 1 | < 0.1% |
| 969580801 | 3 | |
| 972000001 | 1 | < 0.1% |
| 988202869 | 1 | < 0.1% |
| 993251490 | 1 | < 0.1% |
| 994874122 | 1 | < 0.1% |
| 996506774 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 1326266601 | 1 | |
| 1326257441 | 1 | |
| 1326254548 | 1 | |
| 1326253848 | 1 | |
| 1326251875 | 1 | |
| 1326246991 | 1 | |
| 1326241506 | 1 | |
| 1326239004 | 1 | |
| 1326235817 | 1 | |
| 1326234528 | 1 |
user/ageInSeconds
Real number (ℝ)
High correlation Missing
| Distinct | 1471 |
|---|---|
| Distinct (%) | 18.7% |
| Missing | 29644 |
| Missing (%) | 79.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.1767051 × 109 |
| Minimum | 7.0343665 × 108 |
|---|---|
| Maximum | 3.6272954 × 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | 7.0343665 × 108 |
|---|---|
| 5-th percentile | 8.5662385 × 108 |
| Q1 | 9.7948105 × 108 |
| median | 1.100009 × 109 |
| Q3 | 1.2749726 × 109 |
| 95-th percentile | 1.7138846 × 109 |
| Maximum | 3.6272954 × 109 |
| Range | 2.9238588 × 109 |
| Interquartile range (IQR) | 2.954916 × 108 |
Descriptive statistics
| Standard deviation | 3.375514 × 108 |
|---|---|
| Coefficient of variation (CV) | 0.2868615 |
| Kurtosis | 20.514671 |
| Mean | 1.1767051 × 109 |
| Median Absolute Deviation (MAD) | 1.421244 × 108 |
| Skewness | 3.5290889 |
| Sum | 9.2441953 × 1012 |
| Variance | 1.1394094 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1080572647 | 76 | 0.2% |
| 1137506648 | 59 | 0.2% |
| 1351346647 | 56 | 0.1% |
| 1189001047 | 52 | 0.1% |
| 1215788647 | 48 | 0.1% |
| 905004248 | 48 | 0.1% |
| 1579701848 | 47 | 0.1% |
| 1301756647 | 45 | 0.1% |
| 1244300647 | 42 | 0.1% |
| 1378562647 | 40 | 0.1% |
| Other values (1461) | 7343 | 19.6% |
| (Missing) | 29644 |
| Value | Count | Frequency (%) |
| 703436648 | 2 | |
| 733071847 | 1 | < 0.1% |
| 733158247 | 1 | < 0.1% |
| 745427047 | 2 | |
| 751385047 | 1 | < 0.1% |
| 760802647 | 1 | < 0.1% |
| 762793447 | 1 | < 0.1% |
| 776271847 | 2 | |
| 782661847 | 4 | |
| 783266647 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3627295447 | 25 | |
| 3594722648 | 2 | < 0.1% |
| 3581417047 | 35 | |
| 3527676247 | 3 | < 0.1% |
| 2577621848 | 5 | < 0.1% |
| 2366546647 | 9 | < 0.1% |
| 2356956247 | 1 | < 0.1% |
| 2234185447 | 12 | < 0.1% |
| 2233407847 | 2 | < 0.1% |
| 2202476647 | 1 | < 0.1% |
user/birthdayRaw
Date
Missing
| Distinct | 1432 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 29644 |
| Missing (%) | 79.1% |
| Memory size | 293.1 KiB |
| Minimum | 1900-01-01 00:00:00 |
|---|---|
| Maximum | 1992-08-27 00:00:00 |
Histogram with fixed size bins (bins=50)
user/birthdayUnix
Real number (ℝ)
High correlation Missing
| Distinct | 1432 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 29644 |
| Missing (%) | 79.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.4163034 × 108 |
| Minimum | -2.20896 × 109 |
|---|---|
| Maximum | 7.148988 × 108 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 1202 |
| Negative (%) | 3.2% |
| Memory size | 293.1 KiB |
Quantile statistics
| Minimum | -2.20896 × 109 |
|---|---|
| 5-th percentile | -2.955492 × 108 |
| Q1 | 1.433628 × 108 |
| median | 3.183264 × 108 |
| Q3 | 4.388544 × 108 |
| 95-th percentile | 5.617116 × 108 |
| Maximum | 7.148988 × 108 |
| Range | 2.9238588 × 109 |
| Interquartile range (IQR) | 2.954916 × 108 |
Descriptive statistics
| Standard deviation | 3.375514 × 108 |
|---|---|
| Coefficient of variation (CV) | 1.3969744 |
| Kurtosis | 20.514671 |
| Mean | 2.4163034 × 108 |
| Median Absolute Deviation (MAD) | 1.421244 × 108 |
| Skewness | -3.5290889 |
| Sum | 1.898248 × 1012 |
| Variance | 1.1394094 × 1017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 337762800 | 76 | 0.2% |
| 280828800 | 59 | 0.2% |
| 66988800 | 56 | 0.1% |
| 229334400 | 52 | 0.1% |
| 513331200 | 49 | 0.1% |
| 202546800 | 48 | 0.1% |
| -161366400 | 47 | 0.1% |
| 116578800 | 45 | 0.1% |
| 174034800 | 42 | 0.1% |
| 39772800 | 40 | 0.1% |
| Other values (1422) | 7342 | 19.6% |
| (Missing) | 29644 |
| Value | Count | Frequency (%) |
| -2208960000 | 25 | |
| -2176387200 | 2 | < 0.1% |
| -2163081600 | 35 | |
| -2109340800 | 3 | < 0.1% |
| -1159286400 | 5 | < 0.1% |
| -948211200 | 9 | < 0.1% |
| -938620800 | 1 | < 0.1% |
| -815850000 | 12 | < 0.1% |
| -815072400 | 2 | < 0.1% |
| -784141200 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 714898800 | 2 | |
| 685263600 | 1 | < 0.1% |
| 685177200 | 1 | < 0.1% |
| 672908400 | 2 | |
| 666950400 | 1 | < 0.1% |
| 657532800 | 1 | < 0.1% |
| 655542000 | 1 | < 0.1% |
| 642063600 | 2 | |
| 635673600 | 4 | |
| 635068800 | 1 | < 0.1% |
user/gender
Categorical
Imbalance Missing
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 22186 |
| Missing (%) | 59.2% |
| Memory size | 293.1 KiB |
| Male | |
|---|---|
| Female | 245 |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.0319969 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Male |
|---|---|
| 2nd row | Male |
| 3rd row | Male |
| 4th row | Male |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Male | 15069 | |
| Female | 245 | 0.7% |
| (Missing) | 22186 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 15069 | |
| female | 245 | 1.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 15559 | |
| a | 15314 | |
| l | 15314 | |
| M | 15069 | |
| F | 245 | 0.4% |
| m | 245 | 0.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 46432 | |
| Uppercase Letter | 15314 | 24.8% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 15559 | |
| a | 15314 | |
| l | 15314 | |
| m | 245 | 0.5% |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 15069 | |
| F | 245 | 1.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 61746 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 15559 | |
| a | 15314 | |
| l | 15314 | |
| M | 15069 | |
| F | 245 | 0.4% |
| m | 245 | 0.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 61746 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 15559 | |
| a | 15314 | |
| l | 15314 | |
| M | 15069 | |
| F | 245 | 0.4% |
| m | 245 | 0.4% |
user/profileName
Text
| Distinct | 7441 |
|---|---|
| Distinct (%) | 19.8% |
| Missing | 5 |
| Missing (%) | < 0.1% |
| Memory size | 293.1 KiB |
Length
| Max length | 16 |
|---|---|
| Median length | 13 |
| Mean length | 8.9179891 |
| Min length | 3 |
Unique
| Unique | 3157 ? |
|---|---|
| Unique (%) | 8.4% |
Sample
| 1st row | RblWthACoz |
|---|---|
| 2nd row | BeerSox |
| 3rd row | mschofield |
| 4th row | molegar76 |
| 5th row | Brewbro000 |
| Value | Count | Frequency (%) |
| northyorksammy | 141 | 0.4% |
| buckeyenation | 110 | 0.3% |
| mikesgroove | 92 | 0.2% |
| chaingangguy | 84 | 0.2% |
| masterski | 83 | 0.2% |
| akorsak | 81 | 0.2% |
| oberon | 81 | 0.2% |
| barleywinefiend | 80 | 0.2% |
| thorpe429 | 79 | 0.2% |
| smcolw | 74 | 0.2% |
| Other values (7431) | 36590 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 33831 | 10.1% |
| a | 24520 | 7.3% |
| r | 23730 | 7.1% |
| o | 20078 | 6.0% |
| n | 17823 | 5.3% |
| i | 16652 | 5.0% |
| t | 14681 | 4.4% |
| s | 14104 | 4.2% |
| l | 13104 | 3.9% |
| d | 10506 | 3.1% |
| Other values (52) | 145351 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 278753 | |
| Uppercase Letter | 31933 | 9.5% |
| Decimal Number | 23694 | 7.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 33831 | 12.1% |
| a | 24520 | 8.8% |
| r | 23730 | 8.5% |
| o | 20078 | 7.2% |
| n | 17823 | 6.4% |
| i | 16652 | 6.0% |
| t | 14681 | 5.3% |
| s | 14104 | 5.1% |
| l | 13104 | 4.7% |
| d | 10506 | 3.8% |
| Other values (16) | 89724 |
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 4020 | 12.6% |
| S | 2423 | 7.6% |
| D | 2185 | 6.8% |
| M | 2068 | 6.5% |
| T | 1955 | 6.1% |
| C | 1954 | 6.1% |
| G | 1698 | 5.3% |
| J | 1596 | 5.0% |
| A | 1540 | 4.8% |
| R | 1432 | 4.5% |
| Other values (16) | 11062 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 4238 | |
| 0 | 3080 | |
| 2 | 2940 | |
| 7 | 2424 | |
| 3 | 2231 | |
| 8 | 2038 | |
| 9 | 2003 | |
| 4 | 1734 | |
| 5 | 1660 | 7.0% |
| 6 | 1346 | 5.7% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 310686 | |
| Common | 23694 | 7.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 33831 | 10.9% |
| a | 24520 | 7.9% |
| r | 23730 | 7.6% |
| o | 20078 | 6.5% |
| n | 17823 | 5.7% |
| i | 16652 | 5.4% |
| t | 14681 | 4.7% |
| s | 14104 | 4.5% |
| l | 13104 | 4.2% |
| d | 10506 | 3.4% |
| Other values (42) | 121657 |
Common
| Value | Count | Frequency (%) |
| 1 | 4238 | |
| 0 | 3080 | |
| 2 | 2940 | |
| 7 | 2424 | |
| 3 | 2231 | |
| 8 | 2038 | |
| 9 | 2003 | |
| 4 | 1734 | |
| 5 | 1660 | 7.0% |
| 6 | 1346 | 5.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 334380 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 33831 | 10.1% |
| a | 24520 | 7.3% |
| r | 23730 | 7.1% |
| o | 20078 | 6.0% |
| n | 17823 | 5.3% |
| i | 16652 | 5.0% |
| t | 14681 | 4.4% |
| s | 14104 | 4.2% |
| l | 13104 | 3.9% |
| d | 10506 | 3.1% |
| Other values (52) | 145351 |
Interactions
Correlations
| beer/ABV | beer/beerId | beer/brewerId | df_index | review/appearance | review/aroma | review/overall | review/palate | review/taste | review/timeUnix | user/ageInSeconds | user/birthdayUnix | user/gender | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| beer/ABV | 1.000 | 0.403 | 0.159 | -0.167 | 0.310 | 0.421 | 0.219 | 0.382 | 0.400 | 0.235 | -0.125 | 0.125 | 0.000 |
| beer/beerId | 0.403 | 1.000 | 0.499 | -0.310 | 0.022 | 0.084 | 0.002 | 0.065 | 0.059 | 0.392 | -0.086 | 0.086 | 0.000 |
| beer/brewerId | 0.159 | 0.499 | 1.000 | -0.269 | 0.004 | 0.015 | -0.014 | 0.019 | 0.002 | 0.199 | -0.041 | 0.041 | 0.020 |
| df_index | -0.167 | -0.310 | -0.269 | 1.000 | 0.034 | 0.022 | 0.043 | 0.020 | 0.029 | -0.157 | 0.021 | -0.021 | 0.024 |
| review/appearance | 0.310 | 0.022 | 0.004 | 0.034 | 1.000 | 0.495 | 0.460 | 0.515 | 0.493 | 0.060 | -0.050 | 0.050 | 0.006 |
| review/aroma | 0.421 | 0.084 | 0.015 | 0.022 | 0.495 | 1.000 | 0.559 | 0.565 | 0.671 | 0.100 | -0.076 | 0.076 | 0.007 |
| review/overall | 0.219 | 0.002 | -0.014 | 0.043 | 0.460 | 0.559 | 1.000 | 0.645 | 0.721 | 0.058 | -0.054 | 0.054 | 0.000 |
| review/palate | 0.382 | 0.065 | 0.019 | 0.020 | 0.515 | 0.565 | 0.645 | 1.000 | 0.691 | 0.084 | -0.080 | 0.080 | 0.000 |
| review/taste | 0.400 | 0.059 | 0.002 | 0.029 | 0.493 | 0.671 | 0.721 | 0.691 | 1.000 | 0.086 | -0.085 | 0.085 | 0.020 |
| review/timeUnix | 0.235 | 0.392 | 0.199 | -0.157 | 0.060 | 0.100 | 0.058 | 0.084 | 0.086 | 1.000 | -0.277 | 0.277 | 0.037 |
| user/ageInSeconds | -0.125 | -0.086 | -0.041 | 0.021 | -0.050 | -0.076 | -0.054 | -0.080 | -0.085 | -0.277 | 1.000 | -1.000 | 0.033 |
| user/birthdayUnix | 0.125 | 0.086 | 0.041 | -0.021 | 0.050 | 0.076 | 0.054 | 0.080 | 0.085 | 0.277 | -1.000 | 1.000 | 0.033 |
| user/gender | 0.000 | 0.000 | 0.020 | 0.024 | 0.006 | 0.007 | 0.000 | 0.000 | 0.020 | 0.037 | 0.033 | 0.033 | 1.000 |
Missing values
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
Sample
| df_index | beer/ABV | beer/beerId | beer/brewerId | beer/name | beer/style | review/appearance | review/aroma | review/overall | review/palate | review/taste | review/text | review/timeStruct | review/timeUnix | user/ageInSeconds | user/birthdayRaw | user/birthdayUnix | user/gender | user/profileName | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 40163 | 5.0 | 46634 | 14338 | Chiostro | Herbed / Spiced Beer | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | Pours a clouded gold with a thin white head. Nose is quite floral with a larger amount of spices added. Definitely a spice forward fragrance. Flavor has an odd burn that hits on the first sip. After it fades it seems like a dirty vanilla aftertaste. Perhaps this is the absinthe? Regardless of that, I get a quite spiced tone on the tongue. Almost feel a little heat from it. I think that my inexperienced palate on these spices is contributing to my ignorance of what precisely they are. Overall a nice drinker indeed. | {'min': 38, 'hour': 3, 'mday': 16, 'sec': 10, 'year': 2008, 'wday': 1, 'mon': 12, 'isdst': 0, 'yday': 351} | 1229398690 | NaN | NaN | NaN | NaN | RblWthACoz |
| 1 | 8135 | 11.0 | 3003 | 395 | Bearded Pat's Barleywine | American Barleywine | 4.0 | 3.5 | 3.5 | 3.5 | 3.0 | 12oz bottle into 8oz snifter.\t\tDeep ruby red hue with a one finger light tan head that settles to a thin rim along the glass.\t\tSharp piercing hops with some light hard candy in the background. \t\tThe hops provide some bitterness, but they aren't as sharp as I would have expected. Mostly a light candy flavor like in the aroma. Full bodied with good carbonation. The finish is some lingering sweet flavor with a bit of bitterness.\t\tA very sweet barleywine with a weird hard candy flavor that seemed to dominate. Not bad, but I would have liked a little more complexity. | {'min': 38, 'hour': 23, 'mday': 8, 'sec': 58, 'year': 2008, 'wday': 4, 'mon': 8, 'isdst': 0, 'yday': 221} | 1218238738 | NaN | NaN | NaN | NaN | BeerSox |
| 2 | 10529 | 4.7 | 961 | 365 | Naughty Nellie's Ale | American Pale Ale (APA) | 3.5 | 4.0 | 3.5 | 3.5 | 3.5 | First enjoyed at the brewpub about 2 years ago, I finally managed to get a bottle.\tSlightly hazy orange-amber topped with a two finger foamy white head.\tVery nice fruity aroma, soft and floral, tea and toast.\tFruity, slightly grapefruity hop note, toast and biscuity malt balance. Hoppier and more floral when it warms up.\tLight-medium bodied, liked it better on draft but still a solid beer. | {'min': 7, 'hour': 18, 'mday': 26, 'sec': 2, 'year': 2004, 'wday': 4, 'mon': 11, 'isdst': 0, 'yday': 331} | 1101492422 | NaN | NaN | NaN | Male | mschofield |
| 3 | 44610 | 4.4 | 429 | 1 | Pilsner Urquell | Czech Pilsener | 3.0 | 3.0 | 2.5 | 3.0 | 3.0 | First thing I noticed after pouring from green bottle to glass was the skunky smell. Overpowering. Lacing was minimal and faded quickly. Bottle had exp date and was still within freshness date. \t\tTaste was like drinking a milwaukee's best with some skunk. Just couldn't get over the skunky smell to finish my second bottle. Almost $10 a sixer, I would have been better off getting Bud Light. | {'min': 7, 'hour': 1, 'mday': 20, 'sec': 5, 'year': 2011, 'wday': 0, 'mon': 6, 'isdst': 0, 'yday': 171} | 1308532025 | 1.209827e+09 | Aug 10, 1976 | 208508400.0 | Male | molegar76 |
| 4 | 37062 | 4.4 | 4904 | 1417 | Black Sheep Ale (Special) | English Pale Ale | 4.0 | 3.0 | 3.0 | 3.5 | 2.5 | A: pours an amber with a one finger head but only with a very strong pour, head recedes to a light layer of foam with some large bubbles and good lacing\tS: sweet caramel and bread from the English malts comes through, some mild fruityness on the back end\tT: not a lot of complexity with this for me. I didn't expect much considering the style but it's just bland and lacking more bready layers\tM/D: more carbonated than I would have wanted. I would expect this to be much better on cask | {'min': 51, 'hour': 6, 'mday': 12, 'sec': 48, 'year': 2011, 'wday': 5, 'mon': 3, 'isdst': 0, 'yday': 71} | 1299912708 | NaN | NaN | NaN | NaN | Brewbro000 |
| 5 | 14095 | 10.0 | 21436 | 14 | YouEnjoyMyStout | Russian Imperial Stout | 4.0 | 4.0 | 4.0 | 4.0 | 4.5 | served in a snifter; on-tap at CBC.\t\tcolor is the typical imperial stout used motor oil black; impenetrable. by the time the beer arrived at our table the had had receded into a collar around the glass.\t\tnoses offers ample amounts of roastiness, chocolate, molasses and dark fruits, also an atypical tartness to it. not picking up much in the way of bourbon.\t\tflavor imparts more of the same: big notes of roasted malt with chocolate and molasses not far behind, also some dark fruit characters to it and a very distinct and unusual tartness, which adds almost a distinctive flair. more bourbon than i picked up in the aroma but still a subtle presence on that front. medium-full on the palate with average carbonation.\t\toverall a tasty and interesting beer. i like the unique element that the tartness bring; could use a bigger bourbon presence though. also priced very reasonably at $5.50 a glass. | {'min': 16, 'hour': 1, 'mday': 20, 'sec': 9, 'year': 2011, 'wday': 1, 'mon': 12, 'isdst': 0, 'yday': 354} | 1324343769 | NaN | NaN | NaN | NaN | perrymarcus |
| 6 | 13759 | 12.6 | 10001 | 14 | Benevolence | American Wild Ale | 4.0 | 4.5 | 4.0 | 4.0 | 4.0 | my 100th review on-tap! mini snifter\t\t A nutty dark brown color, thin and tanned head with only small lacing all around. \t\t the nose has a fruity, sour and wild yeast aroma up-front. solid, thick and sweet malt underneath, dark fruits, dates and raisins and very tart. \t\t the flavor is a very nice wild-yeast complexity that has tangy and sweet dark fruits, wood-aged alcohol effect along side with a very solid malty balance. wonderful complexity for this wild ale, slightly peppery and herbal on the way down. sour-cherry flavor makes this one really refreshing. Oak and vanilla pop out of the malt in a subtle way and the very end bringa a port wine sweetness.\t\t this one has wonderful balance for a wild yeast ale. | {'min': 1, 'hour': 18, 'mday': 8, 'sec': 12, 'year': 2009, 'wday': 0, 'mon': 6, 'isdst': 0, 'yday': 159} | 1244484072 | NaN | NaN | NaN | NaN | GratefulBeerGuy |
| 7 | 3914 | 8.4 | 52211 | 14879 | Frog's Hollow Double Pumpkin Ale | Pumpkin Ale | 4.0 | 4.0 | 4.0 | 4.0 | 4.0 | One of the better pumpkin ales I've tried so far. Not as imperialized as it may suggest but very nicely balanced and quaffable.\t\tPresentation: 22 oz brown capped bottle. Label pivoting around the image of a standing/hopping frog holding a jar of beer (amber-pumpkin on this version). Perfunctorily terribly designed label with assorted fonts and the standard awful array of blends and color effects with the added novelty of... A picture of the moon under the glow of the name? Side paragraphs offer a general description of the brew, and intent. Lacks any bottling or freshness date. Notes Alc. by Vol. (8.4%), IBUs (7.3), and OG (76). Served in a snifter. \t\tA - Medium amber to orange pumpkin color with a nice creamy head that fades quickly leaving a fair surface memory.\t\tS - Well balanced nose with a characteristic pumpkin sense, sweet and riding on a nice gamut of spices. Good balance, although a bit less and it would be short, hitting the right note with some risk.\t\tT - Follows nicely the smell with a good malt backbone woven with pumpkin and a rich balance of spices complementing the brew.\t\tM - Medium to medium-light body, medium prickly carbonation, finely tuned.\t\tD - Deceptively quaffable given the alcohol bill, which is rather well integrated. Nice pumpkin ale.\t\tNotes: Sure, this could do with an additional hefty note and still be quite notable as a pumpkin ale, but in this incarnation it feels very well rounded, so why touch it? | {'min': 32, 'hour': 20, 'mday': 9, 'sec': 40, 'year': 2010, 'wday': 5, 'mon': 10, 'isdst': 0, 'yday': 282} | 1286656360 | NaN | NaN | NaN | NaN | Daniellobo |
| 8 | 47953 | 9.0 | 34361 | 394 | Stoudt's Barrel Aged Old Abominable | English Barleywine | 4.5 | 4.0 | 4.5 | 4.5 | 4.5 | A snifter filled (several times over) from a 750ml bottle; I pulled this from the dusty clutches of the cellar, a bottle saved for 3+ years from one of my earliest trades. Needed a strong SEPA brew to soften the shocking blow that comes with learning that one of my best friends from high school died today (he was killed by a car while riding his bike in his adopted hometown of Philly ~ a toast to Russ). \t\tThe goofy 'Abominable' cartoon made me smile on an otherwise somber day...\t\tA: Lovely and leathery, an alluring chestnut/garnet, barely translucent. No signs of yeasty bits nor other fatigue from the years in captivity. Starts with about a finger of fizzy but firm khaki cream. A slow droop, then a small break in the topping, then a crescent ring. Slick speckles of lace.\t\tS: Sweet and nutty, toffee and candied fruit - er, fruitcake. A 'buttered rum' quality, but little notable woody/oaky aroma.\t\tT: The requisite toffee, mellowed fruit form a dreamy, dessert-worthy concoction. A little butterscotch (or creme brulee?). Fruity apple pie, something a little brandy-like. Oak, though tame, still holds a fair vanilla bean and charred woodiness. Very well balanced.\t\tM: Velvet, pure velvet...sweetly coating. Modest carbonation and trace amounts of lip-smacking stickiness. Medium thickness. Easy on the tongue, as they say...\t\tD: Love the beer, hate the occasion for opening it. Definitely worth saving, as it's damn delicious and oh so drinkable. Wish I had another; cherish it while you can. That goes for beer and life, both.\t\tThanks to zrrbrrt/jyoungsbcp, aka Josh for sending way back when... | {'min': 26, 'hour': 3, 'mday': 16, 'sec': 13, 'year': 2010, 'wday': 4, 'mon': 7, 'isdst': 0, 'yday': 197} | 1279250773 | NaN | NaN | NaN | Male | msubulldog25 |
| 9 | 7047 | 6.2 | 32676 | 1386 | One Hop Wonder IPA | American IPA | 2.0 | 2.0 | 2.0 | 2.5 | 2.0 | Brewed with five hop additions, this alleged IPA has a slight cidery aroma, zero carbonation, and not a shred of head or lace. It is simple, clear amber.\t\t\tUnfortunately, Harmon really dropped the ball on this fall seasonal. It is green tasting and oddly devoid of even the slightest hop aroma. The 68 IBUs of Glacier hops really dont shine, making this hard to reconcile as a single hop showcase beer. One Hop Wonder is not a completely disastrous ale, but the body is lifeless and the beer remains conceptually undeveloped. Nothing in the taste or aroma remotely resemble an IPA. It tastes like tired yeasts unable to pull their weight, and the finish is deathly. \t\t\tNot up to Harmon standards. | {'min': 26, 'hour': 5, 'mday': 16, 'sec': 41, 'year': 2006, 'wday': 0, 'mon': 10, 'isdst': 0, 'yday': 289} | 1160976401 | NaN | NaN | NaN | NaN | RedDiamond |
| df_index | beer/ABV | beer/beerId | beer/brewerId | beer/name | beer/style | review/appearance | review/aroma | review/overall | review/palate | review/taste | review/text | review/timeStruct | review/timeUnix | user/ageInSeconds | user/birthdayRaw | user/birthdayUnix | user/gender | user/profileName | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 37490 | 46520 | 5.00 | 1550 | 394 | Stoudts American Pale Ale | American Pale Ale (APA) | 3.0 | 3.5 | 4.0 | 3.0 | 3.5 | Light amber color, slightly sweetish fruity nose.\t\tVery smooth and clean taste, with some malty sweetness balanced quite well with some flowery hop notes. Super easy to drink. Not overly full bodied, but still a certain richness. You can tell it has a lot of quality brewed into it. My first Stoudt's product and one that impressed me enough to definitely try the others. | {'min': 56, 'hour': 12, 'mday': 22, 'sec': 16, 'year': 2002, 'wday': 4, 'mon': 2, 'isdst': 0, 'yday': 53} | 1014382576 | 1.344006e+09 | May 10, 1972 | 74329200.0 | Male | bmills1608 |
| 37491 | 22669 | 9.20 | 25852 | 1199 | Founders Blushing Monk | Belgian Strong Pale Ale | 4.0 | 4.5 | 4.5 | 4.5 | 4.5 | 12 oz bottle poured at Belgique tasting, Hugo MN Thanksgiving 2010.\t\tDark ruby brew. Fine bubbles. Delicious tangy raspberry aroma, with an earthy leaf must underlying. Tart and extreme raspberry...incredible lack of any alcohol heat given the greater than 12% ABV. Brett provides a mushroomy flavor. A rich maltiness and slick and sticky mouthfeel. Truly a unique and fabulous brew! | {'min': 5, 'hour': 3, 'mday': 19, 'sec': 56, 'year': 2011, 'wday': 1, 'mon': 4, 'isdst': 0, 'yday': 109} | 1303182356 | 1.497453e+09 | Jun 30, 1967 | -79117200.0 | Male | kenito799 |
| 37492 | 3694 | 6.80 | 33624 | 14879 | Hoppin' To Heaven IPA | American IPA | 3.0 | 3.5 | 3.5 | 3.0 | 3.0 | Received from nlmartin. Thanks!\t\tFizzy off-white head composed of large bubbles. Reduced to a soapy layer that eventually disappeared. Clear, light copper color.\t\tCaramel and some sweet bread malts in the nose. Mostly citrus hops with some bordering on tropical with some bubble gum and raw sugar. Fairly strong, but quite simple.\t\tPretty well balanced. Has a grainy, bread-like malt base. Citrusy hops and some piney notes. Hops are nearly as pronounced as the nose would suggest. Little hints of alcohol.\t\tBody is a bit thin really with low carbonation. Overall seems a bit watery. Flavor lingers for a bit after the swallow.\t\tDrinkability...ehh. Nothing overly noteworthy, but it goes down easy and it does taste like beer. Nothing wrong with it, just mediocre. | {'min': 18, 'hour': 0, 'mday': 16, 'sec': 46, 'year': 2007, 'wday': 5, 'mon': 6, 'isdst': 0, 'yday': 167} | 1181953126 | 1.021216e+09 | Aug 2, 1982 | 397119600.0 | Male | blitz134 |
| 37493 | 32885 | 11.20 | 19960 | 1199 | Founders KBS (Kentucky Breakfast Stout) | American Double / Imperial Stout | 4.0 | 2.0 | 2.5 | 1.0 | 2.0 | Tried a 2011 bottle on May 15 with two of my friends on our "Epic Beer Tasting Day". The line-up consisted of 2010 Darklord, Rare Bourbon County Stout, , 2011 Hanahpu, 2011 KBS, 2010 Abyss.\t\tAppearance - It pours a very dark brown, almost black in appearance. Had a very thin mocha colored head that quickly disappears.\t\tSmell - Bourbon? Nope I didn't smell any of that. I smelled mostly burnt coffee/caramel and nothing else. Disappointing to say the least. \t\tTaste - The alcohol is just too overwhelming in this. I couldn't taste anything but alcohol. I thought it would have a wonderful balanced flavor of coffee, chocolate, vanilla, and bourbon, but got nothing of it.\t\tMouthfeel - Very thick as it coats your whole mouth and burns your throat as it goes down. Not a pleasant experience at all.\t\tOverall - Overrated! Very disappointed. | {'min': 44, 'hour': 4, 'mday': 21, 'sec': 19, 'year': 2011, 'wday': 5, 'mon': 5, 'isdst': 0, 'yday': 141} | 1305953059 | NaN | NaN | NaN | Male | dvsbizzyb |
| 37494 | 11943 | 7.50 | 64848 | 24447 | Li'l Napoleon | American IPA | 4.0 | 3.5 | 4.5 | 4.0 | 4.5 | I had a pint of this at Hopjacks Pizza Kitchen & Taproom on Sunday, September 25, 2011. I specify the date as this beer was phenomenal. I have had it in the past but is seems that this new brewery had hit the nail on the head and perfected its recipe. \t\tA: nice hazy golden color with nice head that stuck around for awhile, good lacing on the glass.\t\tS: this is always my weakest review as I typically have stuffed sinuses...some detections of citrus, hops, wheat.\t\tT: delicious, this rivals some very well known IPAs and is on point for an IPA as far as style characteristics. Had the citrus peel/grapefruit flavor, lots of hops, spices nice refreshing drink.\t\tM: I had ridden my bicycle to the pub and needed a refreshing drink, this hit the spot. Crisp, full of effervescence. \t\tOverall: I have had this beer several times now and this was the best batch thus far. Hope the brewery will be consistent as this could be the beer that launches a thousand barrels. Also hope they start bottling soon. Great job guys. | {'min': 21, 'hour': 16, 'mday': 26, 'sec': 21, 'year': 2011, 'wday': 0, 'mon': 9, 'isdst': 0, 'yday': 269} | 1317054081 | NaN | NaN | NaN | Female | abeerlovr |
| 37495 | 35175 | 5.50 | 22450 | 3268 | Blackberry Scottish-Style | Fruit / Vegetable Beer | 4.0 | 3.5 | 3.5 | 3.5 | 3.5 | 12 oz brown longneck with no freshness dating.\t\tPoured in my SA pint glass, the beer is a hazy brown with gold highlights. There is a huge beige head & decent lacing.\t\tThe aroma is of smoky malts, some berries and brown sugar.\t\tFirst taste is berries followed rapidly by the peaty malts. The berries flavor is neither overwhelming or artificial. More berries in the aftertaste and the beer sweetens. I'd like a little more robust scotch ale as the base for this one. \t\tThe mouth is solid. Drinkablity is tougher. Would I drink all night, no. Would I drink occasionally, yes. Interesting combo is worth searching out. | {'min': 56, 'hour': 23, 'mday': 10, 'sec': 1, 'year': 2008, 'wday': 3, 'mon': 4, 'isdst': 0, 'yday': 101} | 1207871761 | NaN | NaN | NaN | NaN | Redrover |
| 37496 | 23666 | 8.50 | 7463 | 1199 | Founders Dirty Bastard | Scotch Ale / Wee Heavy | 4.5 | 4.0 | 3.5 | 4.5 | 4.5 | A - A bright red with a maroon-amber hue; minimal light tan head but it has very good lacing.\t\tS - Just a great aroma; smells of plum, dark cherry in their purest form; malt and chocolate; molasses/brown sugar smell aroma; you can smell the alcohol.\t\tT - Taste follows the nose and more. Strong flavor of dark fruits that are sugary and coated. A little bit yeasty. A nice hop effect that is pleasantly surprising for this style. Scotchy alcoholic aftertaste. This is a great scotch ale. \t\tM - Excellent. Whole; the sticky head accompanies each sip with an exceptional swallow. Low to medium carbonation. \t\tD - Drinkable but it has a high ABV and is pretty heavy. Two of these and you'll be good for the night. I wouldn't call it sessionable, therefore. \t\tOne of the best beers I've had to date. This is a style I'm pretty unfamiliar with in my young beer drinking days, but this shit is TASTY! | {'min': 45, 'hour': 5, 'mday': 10, 'sec': 14, 'year': 2010, 'wday': 6, 'mon': 1, 'isdst': 0, 'yday': 10} | 1263102314 | NaN | NaN | NaN | NaN | jmerloni |
| 37497 | 47720 | 4.75 | 1154 | 394 | Stoudt's Fest | Märzen / Oktoberfest | 4.0 | 3.5 | 4.0 | 4.5 | 4.0 | Sampled on tap at Redbones.\t\tThis marzen style beer poured a clear, copper color with white foam that settled. The smell was a mild, slightly sweet malty aroma. The taste was slightly sweet (but less sweet than many other of this style) and tangy, malty, with the hops making their presence felt in the finish. There was also a bit of a dry, oaky flavor. The mouthfeel was smooth and creamy up front, but with a dry finish. The body and carbonation were medium. The aftertaste was dry and lingered nicely. This was a good oktoberfest beer. | {'min': 3, 'hour': 1, 'mday': 25, 'sec': 36, 'year': 2003, 'wday': 5, 'mon': 10, 'isdst': 0, 'yday': 298} | 1067043816 | NaN | NaN | NaN | NaN | UncleJimbo |
| 37498 | 33233 | 11.20 | 19960 | 1199 | Founders KBS (Kentucky Breakfast Stout) | American Double / Imperial Stout | 4.0 | 4.0 | 4.0 | 5.0 | 5.0 | Pours a black body with a brown head that very quickly fizzles away to a thin brown lace.\t\tAroma smells of coffee beans, bourbon, chocolate, malt.\t\tTaste a lot of bourbon and coffee right off the bat. Then, hints of chocolate and something very sweet like a syrup. After letting the beer settle I find the flavors come more together as it warms up. An incredibly tasty stout.\t\tMouthfeel is very impressive. Thick, but not too thick with a velvet like feel.\t\tThis beer is heavy and fills you up, also 11.20% so its not a beer you need to drink a whole lot of. Still though, you might find it hard to pass up another glass.\t\tOverall this beer is one of the best stouts i'm yet to have. | {'min': 52, 'hour': 19, 'mday': 29, 'sec': 33, 'year': 2011, 'wday': 5, 'mon': 1, 'isdst': 0, 'yday': 29} | 1296330753 | NaN | NaN | NaN | NaN | Stockfan42 |
| 37499 | 23758 | 8.50 | 7463 | 1199 | Founders Dirty Bastard | Scotch Ale / Wee Heavy | 4.0 | 4.0 | 4.0 | 4.5 | 4.0 | A nice sweet, malty beer...nothing complex, just a smooth refreshing drink that reveals no hint of 8.3 abv.\t\tPours an ice-tea colored brown. If held to the light, the very center of the beer is dense. Lots of light comes through on the sides. Tan head is average size with poor retention. Good lacing. Smell and taste are of caramel malts. Must be balanced very well because it is quite sweet but not cloying or too sweet for mass consumption. Mouthfeel is thick and rich. Drinkability is good. I finished off the 12 oz bottle quickly and could have enjoyed more.\t\tThis is one you have to be in the mood for, but if you are looking for something well made and sweet, this will do it for you. | {'min': 40, 'hour': 18, 'mday': 4, 'sec': 28, 'year': 2009, 'wday': 4, 'mon': 9, 'isdst': 0, 'yday': 247} | 1252089628 | NaN | NaN | NaN | NaN | JayQue |